/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package cs425proj.model;

import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author prateekpatil
 */
public class transaction {
    
    private long creditcard_number;
    private String cc_type;
    private Date expire_date;
    private int cvv_number;
    private Date date_of_transaction;
    private int amount;

    
    public void doTreansaction()
    {
    
        ResultSet rs;
        try{
        connectDB obj = new connectDB();
        
        Statement stm;
        stm =  obj.startConnection().createStatement();
        //Querries
        rs = stm.executeQuery("select distinct(city) from theater");
        while(rs.next()){
            
            
            
        }
        obj.closeConnection();
        }catch(SQLException e){e.printStackTrace();}
    }
    
    public int getAmount() {
        return amount;
    }

    public void setAmount(int amount) {
        this.amount = amount;
    }

    public String getCc_type() {
        return cc_type;
    }

    public void setCc_type(String cc_type) {
        this.cc_type = cc_type;
    }

    public long getCreditcard_number() {
        return creditcard_number;
    }

    public void setCreditcard_number(long creditcard_number) {
        this.creditcard_number = creditcard_number;
    }

    public int getCvv_number() {
        return cvv_number;
    }

    public void setCvv_number(int cvv_number) {
        this.cvv_number = cvv_number;
    }

    public Date getDate_of_transaction() {
        return date_of_transaction;
    }

    public void setDate_of_transaction(Date date_of_transaction) {
        this.date_of_transaction = date_of_transaction;
    }

    public Date getExpire_date() {
        return expire_date;
    }

    public void setExpire_date(Date expire_date) {
        this.expire_date = expire_date;
    }
    
    
    
}
